Release 10.1A: OpenEdge Data Management:
SQL Development

Using the DELETE statement

The DELETE statement deletes table rows specified in the statement’s WHERE clause. If the optional WHERE clause is not specified, then the DELETE statement deletes all rows of the table.

The DELETE statement uses the following syntax:

Syntax

DELETE FROM [ owner_name.] { table_name | view_name } [ WHERE search_condition ] ;

Example 6–9 depicts a simple delete on a single table.

Example 6–9: DELETE statement

DELETE from Customer WHERE Name = 'Hoops' ;

Note: A DELETE statement will fail in the event it attempts to remove rows from primary or candidate keys that reference other tables.